Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 725607 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 72.0 MiB |
| Average record size in memory | 104.0 B |
Variable types
| DateTime | 1 |
|---|---|
| Numeric | 12 |
enhanced_speed is highly correlated with heart_rate and 1 other fields | High correlation |
cadence is highly correlated with heart_rate and 1 other fields | High correlation |
slope_steep is highly correlated with slope_ascent | High correlation |
slope_ascent is highly correlated with slope_steep | High correlation |
slope_descent is highly correlated with slope_steep | High correlation |
heart_rate is highly correlated with enhanced_speed and 1 other fields | High correlation |
enhanced_altitude is highly correlated with temp and 1 other fields | High correlation |
temp is highly correlated with enhanced_altitude and 2 other fields | High correlation |
wind_speed is highly correlated with enhanced_altitude and 2 other fields | High correlation |
wind_direct is highly correlated with temp and 1 other fields | High correlation |
timestamp has unique values | Unique |
wind_direct has 7686 (1.1%) zeros | Zeros |
rain has 410395 (56.6%) zeros | Zeros |
slope_steep has 398827 (55.0%) zeros | Zeros |
slope_ascent has 557781 (76.9%) zeros | Zeros |
slope_descent has 566118 (78.0%) zeros | Zeros |
Reproduction
| Analysis started | 2022-11-02 20:39:06.138677 |
|---|---|
| Analysis finished | 2022-11-02 20:39:57.948301 |
| Duration | 51.81 seconds |
| Software version | pandas-profiling v3.4.0 |
| Download configuration | config.json |
| Distinct | 725607 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.5 MiB |
| Minimum | 2021-11-22 08:05:16 |
|---|---|
| Maximum | 2022-11-01 07:29:54 |
Histogram with fixed size bins (bins=50)
| Distinct | 137 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 143.7379008 |
| Minimum | 58 |
|---|---|
| Maximum | 196 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.5 MiB |
Quantile statistics
| Minimum | 58 |
|---|---|
| 5-th percentile | 119 |
| Q1 | 132 |
| median | 140 |
| Q3 | 154 |
| 95-th percentile | 179 |
| Maximum | 196 |
| Range | 138 |
| Interquartile range (IQR) | 22 |
Descriptive statistics
| Standard deviation | 18.15999403 |
|---|---|
| Coefficient of variation (CV) | 0.1263410271 |
| Kurtosis | -0.06503235764 |
| Mean | 143.7379008 |
| Median Absolute Deviation (MAD) | 10 |
| Skewness | 0.4417108439 |
| Sum | 104297227 |
| Variance | 329.7853831 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 137 | 23806 | 3.3% |
| 136 | 22683 | 3.1% |
| 134 | 22310 | 3.1% |
| 139 | 22235 | 3.1% |
| 140 | 22110 | 3.0% |
| 138 | 21787 | 3.0% |
| 135 | 20882 | 2.9% |
| 133 | 20797 | 2.9% |
| 131 | 20071 | 2.8% |
| 132 | 19540 | 2.7% |
| Other values (127) | 509386 |
| Value | Count | Frequency (%) |
| 58 | 1 | < 0.1% |
| 60 | 2 | < 0.1% |
| 62 | 3 | < 0.1% |
| 63 | 5 | |
| 64 | 2 | < 0.1% |
| 65 | 5 | |
| 66 | 3 | < 0.1% |
| 67 | 6 | |
| 68 | 8 | |
| 69 | 6 |
| Value | Count | Frequency (%) |
| 196 | 1 | < 0.1% |
| 195 | 3 | < 0.1% |
| 194 | 11 | < 0.1% |
| 193 | 23 | < 0.1% |
| 192 | 75 | < 0.1% |
| 191 | 127 | < 0.1% |
| 190 | 487 | 0.1% |
| 189 | 992 | |
| 188 | 1423 | |
| 187 | 1138 |
| Distinct | 4592 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.99702927 |
| Minimum | 3.006 |
|---|---|
| Maximum | 37.3536 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.5 MiB |
Quantile statistics
| Minimum | 3.006 |
|---|---|
| 5-th percentile | 7.6932 |
| Q1 | 10.548 |
| median | 11.4876 |
| Q3 | 12.7296 |
| 95-th percentile | 17.9388 |
| Maximum | 37.3536 |
| Range | 34.3476 |
| Interquartile range (IQR) | 2.1816 |
Descriptive statistics
| Standard deviation | 3.068264164 |
|---|---|
| Coefficient of variation (CV) | 0.2557519945 |
| Kurtosis | 1.676491196 |
| Mean | 11.99702927 |
| Median Absolute Deviation (MAD) | 1.0404 |
| Skewness | 0.5875225596 |
| Sum | 8705128.417 |
| Variance | 9.41424498 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 11.556 | 7522 | 1.0% |
| 11.4552 | 7184 | 1.0% |
| 11.2536 | 7127 | 1.0% |
| 11.1528 | 7067 | 1.0% |
| 11.3544 | 7033 | 1.0% |
| 11.6568 | 6619 | 0.9% |
| 11.052 | 6490 | 0.9% |
| 11.3868 | 6442 | 0.9% |
| 11.7576 | 6370 | 0.9% |
| 11.286 | 6329 | 0.9% |
| Other values (4582) | 657424 |
| Value | Count | Frequency (%) |
| 3.006 | 4 | < 0.1% |
| 3.0132 | 1 | < 0.1% |
| 3.024 | 95 | |
| 3.0276 | 4 | < 0.1% |
| 3.0312 | 1 | < 0.1% |
| 3.0348 | 4 | < 0.1% |
| 3.0564 | 72 | |
| 3.06 | 3 | < 0.1% |
| 3.0672 | 2 | < 0.1% |
| 3.0708 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 37.3536 | 1 | |
| 33.5916 | 1 | |
| 30.9024 | 1 | |
| 30.8376 | 1 | |
| 30.6 | 1 | |
| 30.2328 | 1 | |
| 30.1968 | 2 | |
| 30.1644 | 1 | |
| 30.132 | 1 | |
| 30.0312 | 1 |
distance
Real number (ℝ≥0)
| Distinct | 584854 |
|---|---|
| Distinct (%) | 80.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7071.774407 |
| Minimum | 0 |
|---|---|
| Maximum | 26408.58 |
| Zeros | 2 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 530.226 |
| Q1 | 2844.295 |
| median | 6209.17 |
| Q3 | 10304.765 |
| 95-th percentile | 16884.062 |
| Maximum | 26408.58 |
| Range | 26408.58 |
| Interquartile range (IQR) | 7460.47 |
Descriptive statistics
| Standard deviation | 5107.410842 |
|---|---|
| Coefficient of variation (CV) | 0.7222247979 |
| Kurtosis | -0.127225818 |
| Mean | 7071.774407 |
| Median Absolute Deviation (MAD) | 3651.7 |
| Skewness | 0.7192083419 |
| Sum | 5131329012 |
| Variance | 26085645.51 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 3616.46 | 7 | < 0.1% |
| 4520.74 | 6 | < 0.1% |
| 9411.2 | 6 | < 0.1% |
| 727.62 | 6 | < 0.1% |
| 2377.57 | 6 | < 0.1% |
| 1556.58 | 6 | < 0.1% |
| 8736.22 | 6 | < 0.1% |
| 6809.78 | 6 | < 0.1% |
| 5957.81 | 6 | < 0.1% |
| 1472.7 | 6 | < 0.1% |
| Other values (584844) | 725546 |
| Value | Count | Frequency (%) |
| 0 | 2 | |
| 0.49 | 1 | |
| 0.51 | 1 | |
| 0.67 | 1 | |
| 0.87 | 1 | |
| 0.94 | 1 | |
| 1.08 | 2 | |
| 1.15 | 1 | |
| 1.19 | 1 | |
| 1.25 | 1 |
| Value | Count | Frequency (%) |
| 26408.58 | 1 | |
| 26402.76 | 1 | |
| 26389.24 | 1 | |
| 26371.51 | 1 | |
| 26363.73 | 1 | |
| 26361.95 | 1 | |
| 26360.59 | 2 | |
| 26353.62 | 1 | |
| 26348.24 | 1 | |
| 26347.24 | 1 |
| Distinct | 8222 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 331.9288083 |
| Minimum | 129.4 |
|---|---|
| Maximum | 2438.2 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.5 MiB |
Quantile statistics
| Minimum | 129.4 |
|---|---|
| 5-th percentile | 187.8 |
| Q1 | 198.2 |
| median | 247.6 |
| Q3 | 384.2 |
| 95-th percentile | 659.8 |
| Maximum | 2438.2 |
| Range | 2308.8 |
| Interquartile range (IQR) | 186 |
Descriptive statistics
| Standard deviation | 231.2587409 |
|---|---|
| Coefficient of variation (CV) | 0.6967118704 |
| Kurtosis | 16.78684266 |
| Mean | 331.9288083 |
| Median Absolute Deviation (MAD) | 54.6 |
| Skewness | 3.625091051 |
| Sum | 240849866.8 |
| Variance | 53480.60522 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 376.6 | 16900 | 2.3% |
| 197.6 | 4888 | 0.7% |
| 197.2 | 4497 | 0.6% |
| 198 | 4434 | 0.6% |
| 197.8 | 4429 | 0.6% |
| 197.4 | 4345 | 0.6% |
| 198.6 | 4240 | 0.6% |
| 196.8 | 4173 | 0.6% |
| 199 | 3868 | 0.5% |
| 198.2 | 3853 | 0.5% |
| Other values (8212) | 669980 |
| Value | Count | Frequency (%) |
| 129.4 | 5 | < 0.1% |
| 129.6 | 1 | < 0.1% |
| 129.8 | 9 | < 0.1% |
| 130 | 26 | |
| 130.2 | 20 | < 0.1% |
| 130.4 | 14 | < 0.1% |
| 130.6 | 14 | < 0.1% |
| 130.8 | 14 | < 0.1% |
| 131 | 51 | |
| 131.2 | 26 |
| Value | Count | Frequency (%) |
| 2438.2 | 1 | |
| 2438 | 1 | |
| 2437.4 | 1 | |
| 2433.4 | 1 | |
| 2432.8 | 1 | |
| 2431 | 1 | |
| 2430.6 | 1 | |
| 2429.8 | 1 | |
| 2429.2 | 1 | |
| 2428.2 | 1 |
| Distinct | 98 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 85.88773399 |
| Minimum | 31 |
|---|---|
| Maximum | 128 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.5 MiB |
Quantile statistics
| Minimum | 31 |
|---|---|
| 5-th percentile | 81 |
| Q1 | 85 |
| median | 86 |
| Q3 | 88 |
| 95-th percentile | 93 |
| Maximum | 128 |
| Range | 97 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 6.715580412 |
|---|---|
| Coefficient of variation (CV) | 0.07819021529 |
| Kurtosis | 16.66057908 |
| Mean | 85.88773399 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -3.377655668 |
| Sum | 62320741 |
| Variance | 45.09902027 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 86 | 129296 | |
| 87 | 116370 | |
| 85 | 100010 | |
| 84 | 65768 | |
| 88 | 65666 | |
| 91 | 36057 | 5.0% |
| 89 | 33733 | 4.6% |
| 83 | 33221 | 4.6% |
| 90 | 30295 | 4.2% |
| 92 | 23391 | 3.2% |
| Other values (88) | 91800 |
| Value | Count | Frequency (%) |
| 31 | 4 | < 0.1% |
| 32 | 11 | < 0.1% |
| 33 | 11 | < 0.1% |
| 34 | 6 | < 0.1% |
| 35 | 15 | < 0.1% |
| 36 | 16 | < 0.1% |
| 37 | 24 | < 0.1% |
| 38 | 32 | |
| 39 | 49 | |
| 40 | 70 |
| Value | Count | Frequency (%) |
| 128 | 2 | < 0.1% |
| 127 | 11 | < 0.1% |
| 126 | 6 | < 0.1% |
| 125 | 8 | < 0.1% |
| 124 | 14 | < 0.1% |
| 123 | 17 | < 0.1% |
| 122 | 15 | < 0.1% |
| 121 | 36 | |
| 120 | 54 | |
| 119 | 47 |
| Distinct | 179 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.86533137 |
| Minimum | 0 |
|---|---|
| Maximum | 29.7 |
| Zeros | 1258 |
| Zeros (%) | 0.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1.8 |
| Q1 | 10 |
| median | 16.2 |
| Q3 | 19.6 |
| 95-th percentile | 24.7 |
| Maximum | 29.7 |
| Range | 29.7 |
| Interquartile range (IQR) | 9.6 |
Descriptive statistics
| Standard deviation | 6.988202607 |
|---|---|
| Coefficient of variation (CV) | 0.4701006949 |
| Kurtosis | -0.6668890787 |
| Mean | 14.86533137 |
| Median Absolute Deviation (MAD) | 4.5 |
| Skewness | -0.4344355679 |
| Sum | 10786388.5 |
| Variance | 48.83497568 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 19.2 | 22629 | 3.1% |
| 18.2 | 16028 | 2.2% |
| 18.5 | 15081 | 2.1% |
| 13.6 | 13445 | 1.9% |
| 17.2 | 12703 | 1.8% |
| 16.2 | 12097 | 1.7% |
| 14.5 | 11844 | 1.6% |
| 22.8 | 11135 | 1.5% |
| 24.2 | 10359 | 1.4% |
| 21.2 | 10126 | 1.4% |
| Other values (169) | 590160 |
| Value | Count | Frequency (%) |
| 0 | 1258 | 0.2% |
| 0.1 | 169 | < 0.1% |
| 0.2 | 5122 | |
| 0.3 | 3989 | |
| 0.4 | 2599 | |
| 0.5 | 2805 | |
| 0.6 | 3242 | |
| 0.8 | 1354 | 0.2% |
| 0.9 | 4806 | |
| 1.4 | 2585 |
| Value | Count | Frequency (%) |
| 29.7 | 1325 | 0.2% |
| 27.4 | 5364 | |
| 27.2 | 5253 | |
| 26.7 | 4507 | |
| 26.5 | 5504 | |
| 26.2 | 3735 | |
| 25.2 | 3284 | 0.5% |
| 24.7 | 8212 | |
| 24.6 | 4981 | |
| 24.3 | 7246 |
| Distinct | 106 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.251455264 |
| Minimum | 0 |
|---|---|
| Maximum | 28.1 |
| Zeros | 6855 |
| Zeros (%) | 0.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 4.6 |
| Q1 | 5.7 |
| median | 7 |
| Q3 | 9.7 |
| 95-th percentile | 16.2 |
| Maximum | 28.1 |
| Range | 28.1 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 3.913364814 |
|---|---|
| Coefficient of variation (CV) | 0.4742635921 |
| Kurtosis | 4.348961023 |
| Mean | 8.251455264 |
| Median Absolute Deviation (MAD) | 1.8 |
| Skewness | 1.741321065 |
| Sum | 5987313.7 |
| Variance | 15.31442417 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 4.8 | 35463 | 4.9% |
| 5.8 | 28221 | 3.9% |
| 6.5 | 24876 | 3.4% |
| 9.7 | 22516 | 3.1% |
| 5.2 | 17898 | 2.5% |
| 6.6 | 17775 | 2.4% |
| 5.1 | 17711 | 2.4% |
| 6.2 | 17183 | 2.4% |
| 7.3 | 16966 | 2.3% |
| 9 | 16883 | 2.3% |
| Other values (96) | 510115 |
| Value | Count | Frequency (%) |
| 0 | 6855 | |
| 3.2 | 3244 | 0.4% |
| 3.8 | 1955 | 0.3% |
| 4 | 3938 | |
| 4.2 | 2196 | 0.3% |
| 4.3 | 7189 | |
| 4.4 | 786 | 0.1% |
| 4.5 | 9284 | |
| 4.6 | 1708 | 0.2% |
| 4.7 | 8436 |
| Value | Count | Frequency (%) |
| 28.1 | 1608 | 0.2% |
| 27.8 | 1273 | 0.2% |
| 25.6 | 1032 | 0.1% |
| 25.5 | 1276 | 0.2% |
| 24.8 | 1956 | 0.3% |
| 21.8 | 1083 | 0.1% |
| 21.1 | 1125 | 0.2% |
| 19.7 | 5126 | |
| 19.4 | 1060 | 0.1% |
| 18.4 | 3707 |
| Distinct | 182 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 207.187902 |
| Minimum | 0 |
|---|---|
| Maximum | 358 |
| Zeros | 7686 |
| Zeros (%) | 1.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 17 |
| Q1 | 123 |
| median | 235 |
| Q3 | 294 |
| 95-th percentile | 343 |
| Maximum | 358 |
| Range | 358 |
| Interquartile range (IQR) | 171 |
Descriptive statistics
| Standard deviation | 103.0447797 |
|---|---|
| Coefficient of variation (CV) | 0.4973494046 |
| Kurtosis | -0.9519302321 |
| Mean | 207.187902 |
| Median Absolute Deviation (MAD) | 74 |
| Skewness | -0.4834566878 |
| Sum | 150336992 |
| Variance | 10618.22662 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 246 | 15152 | 2.1% |
| 298 | 15015 | 2.1% |
| 83 | 13745 | 1.9% |
| 343 | 13187 | 1.8% |
| 307 | 12655 | 1.7% |
| 317 | 12012 | 1.7% |
| 271 | 11734 | 1.6% |
| 210 | 11616 | 1.6% |
| 328 | 10763 | 1.5% |
| 131 | 10568 | 1.5% |
| Other values (172) | 599160 |
| Value | Count | Frequency (%) |
| 0 | 7686 | |
| 1 | 2862 | 0.4% |
| 3 | 5112 | |
| 5 | 1204 | 0.2% |
| 7 | 4981 | |
| 9 | 5223 | |
| 10 | 4719 | |
| 12 | 2268 | 0.3% |
| 13 | 1282 | 0.2% |
| 17 | 5242 |
| Value | Count | Frequency (%) |
| 358 | 6881 | |
| 357 | 1571 | 0.2% |
| 355 | 4271 | 0.6% |
| 354 | 1644 | 0.2% |
| 353 | 1663 | 0.2% |
| 352 | 4404 | 0.6% |
| 351 | 1864 | 0.3% |
| 347 | 2650 | 0.4% |
| 344 | 5722 | |
| 343 | 13187 |
| Distinct | 69 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.627155058 |
| Minimum | 0 |
|---|---|
| Maximum | 84.6 |
| Zeros | 410395 |
| Zeros (%) | 56.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1.5 |
| 95-th percentile | 13.2 |
| Maximum | 84.6 |
| Range | 84.6 |
| Interquartile range (IQR) | 1.5 |
Descriptive statistics
| Standard deviation | 8.284247731 |
|---|---|
| Coefficient of variation (CV) | 3.153315107 |
| Kurtosis | 66.90221515 |
| Mean | 2.627155058 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.381606365 |
| Sum | 1906282.1 |
| Variance | 68.62876047 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 410395 | |
| 0.5 | 22338 | 3.1% |
| 0.1 | 19937 | 2.7% |
| 7.6 | 13376 | 1.8% |
| 3.3 | 12859 | 1.8% |
| 0.3 | 12612 | 1.7% |
| 1.1 | 11557 | 1.6% |
| 0.2 | 11136 | 1.5% |
| 1.4 | 10561 | 1.5% |
| 2.8 | 8796 | 1.2% |
| Other values (59) | 192040 |
| Value | Count | Frequency (%) |
| 0 | 410395 | |
| 0.1 | 19937 | 2.7% |
| 0.2 | 11136 | 1.5% |
| 0.3 | 12612 | 1.7% |
| 0.4 | 8714 | 1.2% |
| 0.5 | 22338 | 3.1% |
| 0.6 | 1505 | 0.2% |
| 0.7 | 1311 | 0.2% |
| 0.8 | 6548 | 0.9% |
| 0.9 | 1537 | 0.2% |
| Value | Count | Frequency (%) |
| 84.6 | 5223 | |
| 23.3 | 1337 | 0.2% |
| 22.6 | 4519 | |
| 21.9 | 6401 | |
| 19.3 | 5419 | |
| 18.9 | 3365 | |
| 18.5 | 3198 | |
| 18 | 1523 | 0.2% |
| 16.1 | 1882 | 0.3% |
| 16 | 957 | 0.1% |
| Distinct | 65517 |
|---|---|
| Distinct (%) | 9.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.317642683 |
| Minimum | 0 |
|---|---|
| Maximum | 45 |
| Zeros | 398827 |
| Zeros (%) | 55.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 5.899705015 |
| 95-th percentile | 13.21585903 |
| Maximum | 45 |
| Range | 45 |
| Interquartile range (IQR) | 5.899705015 |
Descriptive statistics
| Standard deviation | 5.724116275 |
|---|---|
| Coefficient of variation (CV) | 1.725356472 |
| Kurtosis | 16.43551932 |
| Mean | 3.317642683 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.365246875 |
| Sum | 2407304.754 |
| Variance | 32.76550713 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 398827 | |
| 45 | 2503 | 0.3% |
| 6.153846154 | 968 | 0.1% |
| 6.666666667 | 901 | 0.1% |
| 6.309148265 | 703 | 0.1% |
| 6.472491909 | 680 | 0.1% |
| 6.329113924 | 672 | 0.1% |
| 6.493506494 | 641 | 0.1% |
| 6.230529595 | 620 | 0.1% |
| 6.006006006 | 583 | 0.1% |
| Other values (65507) | 318509 |
| Value | Count | Frequency (%) |
| 0 | 398827 | |
| 0.4866180049 | 1 | < 0.1% |
| 0.6013229104 | 1 | < 0.1% |
| 0.6040471157 | 1 | < 0.1% |
| 0.641025641 | 1 | < 0.1% |
| 0.6715916723 | 1 | < 0.1% |
| 0.6747638327 | 1 | < 0.1% |
| 0.6752194463 | 1 | < 0.1% |
| 0.705716302 | 1 | < 0.1% |
| 0.7293946025 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 45 | 2503 | |
| 45 | 1 | < 0.1% |
| 44.98977505 | 1 | < 0.1% |
| 44.94382022 | 2 | < 0.1% |
| 44.94382022 | 2 | < 0.1% |
| 44.94382022 | 3 | < 0.1% |
| 44.94382022 | 1 | < 0.1% |
| 44.94382022 | 2 | < 0.1% |
| 44.94382022 | 1 | < 0.1% |
| 44.94382022 | 2 | < 0.1% |
| Distinct | 70 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.07660538005 |
| Minimum | 0 |
|---|---|
| Maximum | 10 |
| Zeros | 557781 |
| Zeros (%) | 76.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0.4 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.1938750442 |
|---|---|
| Coefficient of variation (CV) | 2.530828045 |
| Kurtosis | 145.4521861 |
| Mean | 0.07660538005 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 6.600243448 |
| Sum | 55585.4 |
| Variance | 0.03758753278 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 557781 | |
| 0.2 | 70644 | 9.7% |
| 0.2 | 40130 | 5.5% |
| 0.4 | 19704 | 2.7% |
| 0.4 | 7911 | 1.1% |
| 0.6 | 7855 | 1.1% |
| 1 | 3367 | 0.5% |
| 0.8 | 3293 | 0.5% |
| 0.2 | 2938 | 0.4% |
| 0.6 | 2863 | 0.4% |
| Other values (60) | 9121 | 1.3% |
| Value | Count | Frequency (%) |
| 0 | 557781 | |
| 0.2 | 2938 | 0.4% |
| 0.2 | 40130 | 5.5% |
| 0.2 | 70644 | 9.7% |
| 0.2 | 181 | < 0.1% |
| 0.4 | 84 | < 0.1% |
| 0.4 | 1740 | 0.2% |
| 0.4 | 19704 | 2.7% |
| 0.4 | 7911 | 1.1% |
| 0.6 | 2863 | 0.4% |
| Value | Count | Frequency (%) |
| 10 | 9 | |
| 9.2 | 1 | < 0.1% |
| 8.8 | 1 | < 0.1% |
| 8.4 | 1 | < 0.1% |
| 7.6 | 1 | < 0.1% |
| 7.4 | 1 | < 0.1% |
| 6.8 | 2 | < 0.1% |
| 6.2 | 1 | < 0.1% |
| 5.6 | 1 | < 0.1% |
| 5.4 | 1 | < 0.1% |
| Distinct | 70 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.07482066739 |
| Minimum | 0 |
|---|---|
| Maximum | 10 |
| Zeros | 566118 |
| Zeros (%) | 78.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0.4 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.1931662291 |
|---|---|
| Coefficient of variation (CV) | 2.581722883 |
| Kurtosis | 77.02879606 |
| Mean | 0.07482066739 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.446922976 |
| Sum | 54290.4 |
| Variance | 0.03731319206 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 566118 | |
| 0.2 | 65047 | 9.0% |
| 0.2 | 38451 | 5.3% |
| 0.4 | 19006 | 2.6% |
| 0.4 | 7704 | 1.1% |
| 0.6 | 7657 | 1.1% |
| 1 | 3478 | 0.5% |
| 0.8 | 3367 | 0.5% |
| 0.6 | 3203 | 0.4% |
| 0.2 | 2086 | 0.3% |
| Other values (60) | 9490 | 1.3% |
| Value | Count | Frequency (%) |
| 0 | 566118 | |
| 0.2 | 2086 | 0.3% |
| 0.2 | 38451 | 5.3% |
| 0.2 | 65047 | 9.0% |
| 0.2 | 99 | < 0.1% |
| 0.4 | 66 | < 0.1% |
| 0.4 | 1656 | 0.2% |
| 0.4 | 19006 | 2.6% |
| 0.4 | 7704 | 1.1% |
| 0.6 | 3203 | 0.4% |
| Value | Count | Frequency (%) |
| 10 | 2 | |
| 8.4 | 2 | |
| 7.8 | 1 | |
| 7.6 | 1 | |
| 6.8 | 1 | |
| 6.6 | 1 | |
| 6.4 | 1 | |
| 6.4 | 1 | |
| 6.2 | 1 | |
| 6 | 1 |
Auto
The auto setting is an easily interpretable pairwise column metric of the following mapping: vartype-vartype : method, categorical-categorical : Cramer's V, numerical-categorical : Cramer's V (using a discretized numerical column), numerical-numerical : Spearman's ρ. This configuration uses the best suitable for each pair of columns.Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
First rows
| timestamp | heart_rate | enhanced_speed | distance | enhanced_altitude | cadence | temp | wind_speed | wind_direct | rain | slope_steep | slope_ascent | slope_descent | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2021-11-22 08:05:16 | 85.0 | 6.5160 | 2.00 | 249.4 | 56.0 | 5.3 | 8.7 | 320.0 | 0.5 | 0.000000 | 0.0 | 0.0 |
| 1 | 2021-11-22 08:05:22 | 87.0 | 11.1528 | 23.28 | 249.4 | 86.0 | 5.3 | 8.7 | 320.0 | 0.5 | 0.000000 | 0.0 | 0.0 |
| 2 | 2021-11-22 08:05:26 | 90.0 | 14.6448 | 39.91 | 249.4 | 86.0 | 5.3 | 8.7 | 320.0 | 0.5 | 0.000000 | 0.0 | 0.0 |
| 3 | 2021-11-22 08:05:29 | 93.0 | 14.1084 | 52.04 | 249.0 | 86.0 | 5.3 | 8.7 | 320.0 | 0.5 | 3.297609 | 0.0 | 0.4 |
| 4 | 2021-11-22 08:05:30 | 96.0 | 13.1328 | 56.29 | 249.2 | 85.0 | 5.3 | 8.7 | 320.0 | 0.5 | 4.705882 | 0.2 | 0.0 |
| 5 | 2021-11-22 08:05:32 | 99.0 | 11.8584 | 63.36 | 248.6 | 83.0 | 5.3 | 8.7 | 320.0 | 0.5 | 8.486563 | 0.0 | 0.6 |
| 6 | 2021-11-22 08:05:34 | 101.0 | 11.5560 | 67.97 | 248.8 | 84.0 | 5.3 | 8.7 | 320.0 | 0.5 | 4.338395 | 0.2 | 0.0 |
| 7 | 2021-11-22 08:05:35 | 102.0 | 11.0520 | 69.32 | 249.2 | 84.0 | 5.3 | 8.7 | 320.0 | 0.5 | 29.629630 | 0.4 | 0.0 |
| 8 | 2021-11-22 08:05:37 | 105.0 | 7.0200 | 71.68 | 249.2 | 83.0 | 5.3 | 8.7 | 320.0 | 0.5 | 0.000000 | 0.0 | 0.0 |
| 9 | 2021-11-22 08:05:41 | 108.0 | 7.5240 | 80.99 | 249.2 | 80.0 | 5.3 | 8.7 | 320.0 | 0.5 | 0.000000 | 0.0 | 0.0 |
Last rows
| timestamp | heart_rate | enhanced_speed | distance | enhanced_altitude | cadence | temp | wind_speed | wind_direct | rain | slope_steep | slope_ascent | slope_descent | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 725597 | 2022-11-01 07:29:45 | 158.0 | 15.0480 | 11163.65 | 244.0 | 92.0 | 12.6 | 4.8 | 307.0 | 1.4 | 9.592326 | 0.4 | 0.0 |
| 725598 | 2022-11-01 07:29:46 | 158.0 | 14.9796 | 11167.81 | 244.2 | 92.0 | 12.6 | 4.8 | 307.0 | 1.4 | 4.807692 | 0.2 | 0.0 |
| 725599 | 2022-11-01 07:29:47 | 159.0 | 14.9148 | 11171.96 | 244.4 | 91.0 | 12.6 | 4.8 | 307.0 | 1.4 | 4.819277 | 0.2 | 0.0 |
| 725600 | 2022-11-01 07:29:48 | 158.0 | 14.7816 | 11176.06 | 244.6 | 90.0 | 12.6 | 4.8 | 307.0 | 1.4 | 4.878049 | 0.2 | 0.0 |
| 725601 | 2022-11-01 07:29:49 | 159.0 | 14.6448 | 11180.14 | 245.0 | 90.0 | 12.6 | 4.8 | 307.0 | 1.4 | 9.803922 | 0.4 | 0.0 |
| 725602 | 2022-11-01 07:29:50 | 161.0 | 14.5800 | 11184.18 | 245.2 | 90.0 | 12.6 | 4.8 | 307.0 | 1.4 | 4.950495 | 0.2 | 0.0 |
| 725603 | 2022-11-01 07:29:51 | 160.0 | 14.5440 | 11188.23 | 245.4 | 90.0 | 12.6 | 4.8 | 307.0 | 1.4 | 4.938272 | 0.2 | 0.0 |
| 725604 | 2022-11-01 07:29:52 | 161.0 | 14.6124 | 11192.28 | 245.4 | 91.0 | 12.6 | 4.8 | 307.0 | 1.4 | 0.000000 | 0.0 | 0.0 |
| 725605 | 2022-11-01 07:29:53 | 162.0 | 14.6448 | 11196.35 | 245.8 | 90.0 | 12.6 | 4.8 | 307.0 | 1.4 | 9.828010 | 0.4 | 0.0 |
| 725606 | 2022-11-01 07:29:54 | 161.0 | 14.3784 | 11200.34 | 246.0 | 89.0 | 12.6 | 4.8 | 307.0 | 1.4 | 5.012531 | 0.2 | 0.0 |